﻿CREATE TABLE [dbo].[User] (
    [Id]           INT           IDENTITY (1, 1) NOT NULL,
    [Firstname]    NVARCHAR (50) NOT NULL,
    [Lastname]     NVARCHAR (50) NOT NULL,
    [Email]        NVARCHAR (50) NOT NULL,
    [PO]           NVARCHAR (50) NOT NULL,
    [DellBadgeNo]  NVARCHAR (10) NOT NULL, 
    [IsAdmin]      BIT           NOT NULL,
    [IsActive]     BIT           NOT NULL,
    [Password]     VARCHAR (200) NOT NULL,
    [PasswordSalt] VARCHAR (200) NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC)
);

